package com.qf.mapper;


import com.qf.pojo.Categories;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by jackiechan on 2021/6/7 15:32
 *
 * @author jackiechan
 */

public interface CategoryMapper {
    @Select("SELECT * FROM categories")
        // @SelectProvider(type = UserSqlProvider.class,method = "getQueryByNameAndStaus")
    List<Categories> findAllCategories();

    @Insert("INSERT INTO categories (categoryname,txcommand,rxcommand,commandname,status) VALUE(#{categoryname},#{txcommand},#{rxcommand},#{commandname},#{status})")
    void addCategoy(Categories categories);
}